package com.crealth.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.crealth.model.SipAccountModel;


public abstract interface SipAccountMapper {
	
    public abstract List<SipAccountModel> selectAllSipAccount();
    
    public abstract void insertSipAccount(
    		@Param("sipAccount")String sipAccount,
    		@Param("sipPwd")String sipPwd);
    
    public abstract void insertDispathRecord(
    		@Param("tbName")String tbName,
    		@Param("userID")int userID,
    		@Param("sipAct")String sipAct,
    		@Param("setOP")int setOP);
    
    public abstract void createDispathRecord(
    		@Param("tbName")String tbName);
    
    public abstract SipAccountModel selectOneUnuseSipAccount();
    
    public abstract Integer updateSipAccountStatus(
    		@Param("sipAct")String sipAct,
    		@Param("setStatus")int setStatus,
    		@Param("setUserID")int setUserID);
    
    public abstract void updateStatusSipAccountByUserID(
    		@Param("userID")int userID,
    		@Param("setStatus")int setStatus,
    		@Param("setUserID")int setUserID);
    
    public abstract void reuseAllSipAccount();
    
    
}
